----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  F:/Dropbox (UBC-Umich)/Research_Projects/Project Javier and Natalia/TFP firm/TFP_firm_data_historical/dataverse_files/code/logs/table_A3_N_R2_MSE.log
  log type:  text
 opened on:  15 Nov 2022, 00:27:40

. *-------------------------------------------------------------------------------
. 
. 
. 
. *------------------------------------------------------------------------------
. *Generate Table A3
. *------------------------------------------------------------------------------
. clear all

. set obs 100
number of observations (_N) was 0, now 100

. 
. gen model=""
(100 missing values generated)

. gen num_obs=. 
(100 missing values generated)

. gen R2=. 
(100 missing values generated)

. gen rms=. 
(100 missing values generated)

. tempfile temp

. save `temp', replace 
(note: file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp not found)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved

. 
. 
. local iter=0

. 
. foreach rsample in "naics_sales_s1_base_woparent" "naics_emp_s1_base_woparent_salesempva" "naics_va_s1_base_woparent_salesempva" "naics_sales_s1_base_withparent" "naics_sales_s
> 1_base_woparent_decile_2_9" "naics_sales_s1_base_woparent_decile_3_8" "naics_sales_s1_base_woparent_decile_4_7" "naics_sales_s1_base_woparent_decile_5_6" "naics_sales_s1_base_w
> oparent_above3ctry" "naics_sales_s1_base_woparent_above5ctry" "naics_sales_s1_base_woparent_above10ctry" "naics4_sales_s1_base_woparent"  "naics_sales_s1_base_woparent_exclnoma
> rk" "naics_sales_s1_base_woparent_ctte" "naics_sales_s1_base_woparent_aboveage10" "naics_sales_s1_base_woparent_gdpdiff" "naics_sales_s1_base_woparent_tax_ratio" "naics_sales_s
> 1_base_woparent_BTT" "naics_sales_s1_base_woparent_nogravity"  {
  2. 
. display "`rsample'"
  3. clear all  
  4. local iter=`iter'+1
  5. display "`iter'"
  6. 
. use "${data}/R2_`rsample'.dta", clear
  7. sum num_obs
  8. global num_obs_`iter'=`r(mean)'
  9. display "${num_obs_`iter'}"
 10. sum rms
 11. global rms_`iter'=`r(mean)'
 12. sum R2
 13. global R2_`iter'=`r(mean)'
 14. display "${R2_`iter'}"
 15. 
. use `temp', clear
 16. replace model="`rsample'" if _n==`iter'
 17. replace num_obs=${num_obs_`iter'} if _n==`iter'
 18. replace rms=${rms_`iter'} if _n==`iter'
 19. replace R2=${R2_`iter'} if _n==`iter'
 20. replace model="Baseline" if _n==1
 21. 
. format %9.2fc rms R2
 22. format %9.0fc num_obs
 23. save, replace 
 24. 
. }
naics_sales_s1_base_woparent
1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       49811           .      49811      49811
49811

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1     1.43218           .    1.43218    1.43218

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .7009836           .   .7009836   .7009836
.7009835839271545
variable model was str1 now str28
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_emp_s1_base_woparent_salesempva
2

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       41697           .      41697      41697
41697

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.313058           .   1.313058   1.313058

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1     .762079           .    .762079    .762079
.7620790004730225
variable model was str28 now str37
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_va_s1_base_woparent_salesempva
3

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       27284           .      27284      27284
27284

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1     1.29537           .    1.29537    1.29537

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .7452997           .   .7452997   .7452997
.7452996969223022
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_withparent
4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       70353           .      70353      70353
70353

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.461756           .   1.461756   1.461756

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1     .721669           .    .721669    .721669
.7216689586639404
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_decile_2_9
5

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       38652           .      38652      38652
38652

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.060423           .   1.060423   1.060423

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .7429506           .   .7429506   .7429506
.7429505586624146
variable model was str37 now str39
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_decile_3_8
6

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       27272           .      27272      27272
27272

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    .7952275           .   .7952275   .7952275

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .8111822           .   .8111822   .8111822
.8111822009086609
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_decile_4_7
7

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       16218           .      16218      16218
16218

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    .5460742           .   .5460742   .5460742

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .8944284           .   .8944284   .8944284
.8944284319877625
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_decile_5_6
8

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1        6120           .       6120       6120
6120

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    .2849392           .   .2849392   .2849392

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1     .972092           .    .972092    .972092
.9720920324325562
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_above3ctry
9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       38707           .      38707      38707
38707

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.433438           .   1.433438   1.433438

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .6592125           .   .6592125   .6592125
.6592124700546265
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_above5ctry
10

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       26298           .      26298      26298
26298

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.423246           .   1.423246   1.423246

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .6151149           .   .6151149   .6151149
.6151148676872253
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_above10ctry
11

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       11682           .      11682      11682
11682

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1     1.34209           .    1.34209    1.34209

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1     .577375           .    .577375    .577375
.5773749947547913
variable model was str39 now str40
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics4_sales_s1_base_woparent
12

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       59088           .      59088      59088
59088

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.541636           .   1.541636   1.541636

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .6341915           .   .6341915   .6341915
.6341914534568787
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_exclnomark
13

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       47584           .      47584      47584
47584

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.430691           .   1.430691   1.430691

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1     .700893           .    .700893    .700893
.7008929848670959
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_ctte
14

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       32396           .      32396      32396
32396

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.335342           .   1.335342   1.335342

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .7181717           .   .7181717   .7181717
.7181717157363892
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_aboveage10
15

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       37390           .      37390      37390
37390

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.380946           .   1.380946   1.380946

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .7087177           .   .7087177   .7087177
.7087177038192749
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_gdpdiff
16

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       48955           .      48955      48955
48955

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.431406           .   1.431406   1.431406

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .7009734           .   .7009734   .7009734
.7009733915328979
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_tax_ratio
17

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       49811           .      49811      49811
49811

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.431776           .   1.431776   1.431776

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .7013004           .   .7013004   .7013004
.7013004422187805
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_BTT
18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       49811           .      49811      49811
49811

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.431754           .   1.431754   1.431754

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .7013096           .   .7013096   .7013096
.7013095617294312
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved
naics_sales_s1_base_woparent_nogravity
19

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     num_obs |          1       50649           .      50649      50649
50649

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         rms |          1    1.441442           .   1.441442   1.441442

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          R2 |          1    .6968069           .   .6968069   .6968069
.6968069076538086
(1 real change made)
(1 real change made)
(1 real change made)
(1 real change made)
(0 real changes made)
file C:\Users\VANESS~1\AppData\Local\Temp\ST_324c_000007.tmp saved

. 
. drop if model==""
(81 observations deleted)

. 
. *Export table to excel
. export delimited using "${rappendix}/table_A3_N_R2_MSE.csv", datafmt replace
(note: file F:/Dropbox (UBC-Umich)/Research_Projects/Project Javier and Natalia/TFP firm/TFP_firm_data_historical/dataverse_files/results/appendix/table_A3_N_R2_MSE.csv not found
> )
file F:/Dropbox (UBC-Umich)/Research_Projects/Project Javier and Natalia/TFP firm/TFP_firm_data_historical/dataverse_files/results/appendix/table_A3_N_R2_MSE.csv saved

. 
. log close
      name:  <unnamed>
       log:  F:/Dropbox (UBC-Umich)/Research_Projects/Project Javier and Natalia/TFP firm/TFP_firm_data_historical/dataverse_files/code/logs/table_A3_N_R2_MSE.log
  log type:  text
 closed on:  15 Nov 2022, 00:27:40
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
